| |
|
|
|
This ASP.NET server control creates a spreadsheet grid and enables formulas, numbers, text, labels and dates in cells. Use in financial calculators or anywhere else a spreadsheet template is used...albeit in a web page!
FAQ
What functions are supported (Sum(),Year(), etc.)?
All functionality from the .NET System.dll framework are supported. For example:
Basic math: [c0r0]+[c0r1]
System.Math namespace: Math.Pow(1+[c1r7],2)
Strings: `[c0r1]`.Trim().Replace(`$`,``).Substring(0,1)
Dates: DateTime d=new DateTime([c1r0]);return d.Year;
Formula cell references such as `[c0r1]` are replaced by the value of the cell, then evaluated. (Note that the value of a date cell is the number of ticks.) So the above examples might look like this before being evaluated:
Basic math: 100+200
System.Math namespace: Math.Pow(1+.045,2)
Strings: `$57`.Trim().Replace(`$`,``).Substring(0,1)
Dates:DateTime d=new DateTime(632272996777884556);return d.Year;
Formula cells are created like this:
Spread1.AddCell(new FormulaCell(1,6,`[c1r4]*[c2r6]`,`Formula`,NumericFormats.ToTheDollar));
See below for more examples of how formula cells work. Note also that there are two kinds of formulas, simple and multiline. The example below shows both types of formulas.
Code used in this example
Initialization of a spreadsheet
Using Mayersoft.Web.Controls;
private void Page_Init(object sender, System.EventArgs e)
{
Spread1.LicenseKey=`eL!NJ@2H3aF`;//sample key
}
private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
Spread1.Columns.Add(new Column(150));
Spread1.Columns.Add(new Column());
Spread1.AddCell(new Cell(0,0,`Item 1`,`Label`));
Spread1.AddCell(new Cell(0,1,`Item 2`,`Label`));
Spread1.AddCell(new Cell(0,2,`Total`,`Label`));
Spread1.AddCell(new Cell(0,3,`Div by pct`,`Label`));
Spread1.AddCell(new Cell(0,4,`Result`,`Label`));
Spread1.AddCell(new Cell(0,5,`Price |
| « read more about MayerSoft.Web.Controls.Spreadsheet 1.0 |
|
|
RECOMMENDED DOWNLOADS IN THIS CATEGORY
|
|
|
|
| » Nevron Chart for Windows Forms 3.0
|
| Nevron Chart for Windows Forms is the leading charting component for Windows Forms applications. The component delivers rich charting functionality suitable for presentation, scientific, financial and business charts. This combined with the presentation â ... |
|
| Nevron LLC | 10198KB | Win 95/98/ME/NT/2000/XP | $489 | Downloads: 1644 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Pacestar UML Diagrammer 4.19
|
| Creates UML diagrams quickly and easily. Develop, document, and communicate your designs in a systematic yet flexible commonly understood notation. Supports activity, class and object, use case, sequence, state, package, and component deployment diagrams. ... |
|
| Pacestar Software | 2703KB | Win 95/98/ME/NT/2000/XP | $49.95 | Downloads: 1712 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| |
| Configuration Management Services Limited | 14666KB | Win NT/2000/XP | $150 | Downloads: 1611 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » VB-PowerWrap 4.0
|
| Distribute your apps without worrying about runtime dependencies. VB-PowerWrap scans a VB project, wraps all dll`s & ocx`s, and creates a self-contained file for distribution. Also lets you embed all dependent/non-dependant files, including graphics, da ... |
|
| Moonlight Software | 1451KB | Win 95/98/ME/NT/2000/XP | $49.95 | Downloads: 1659 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » PopulateMSI 1.3
|
| The easy and powerful way to create Windows(r) Installer Packages (*.MSI files). Simple installer wizard interface allows creation of full-blown Windows(r) installations. Components and Features - The Windows(r) Installer organizes an installation aroun ... |
|
| Object Design Labs, Inc. | 1851KB | Win NT/2000/XP | $199.00 | Downloads: 1658 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » HTMLHELPER 1.0
|
| This program creates HTML help files for your programs. It collects the information that you put in into a database and when you decide to make the files, it creates the files and sends them to the required Microsoft HTML Help Compiler. You can quickly b ... |
|
| Cole Software Technologies | 1000KB | Win 95/98/ME/XP | $55.00 | Downloads: 1707 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Shorty 1.001
|
| Shorty analyses Visual Basic forms identifying duplicate shortcuts and lonely little controls that have no shortcut. When these confused or lost souls are found shortcuts are suggested, or changes in other controls that will free a suitable shortcut. ... |
|
| NaTCH Engineering | 2301KB | Win 95/98/ME/NT/2000/XP | $19.50 | Downloads: 1730 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Affiliate Creator 1.0
|
| Affiliate Creator is a shareware tool that enables shareware authors to batch build customized installers for their affiliates.You can also use it to build stand-alone applications named Self-Creator and publish them on your website so that your affiliate ... |
|
| Affiliate Creator | 1850KB | Win 98/ME/NT/2000/XP | $39.75 | Downloads: 1742 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Hotspot Builder 1.21
|
| Hotspot Builder is a tool intended for creating hotspots on graphic images used in Win- and HTML- help systems. Hotspots are special regions which can work as links to help topics, popup links and help macros when clicking on them. Hotspot Builder provide ... |
|
| Divcom Software | 885KB | Win 95/98/ME/NT/2000/XP | $46.95 | Downloads: 1649 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » DiffnMerge 1.3
|
| Quick and Easy File and Folder Comparing. With Drasbek DiffnMerge you can compare and merge files and folders. Compare two text files and see the differences in the two files side by side, then merge the text files manually or automatically by inserting t ... |
|
| Drasbek Data | 2400KB | Win 98/ME/NT/2000/XP | $29 | Downloads: 1720 |
| Date added: Sep 22, 2005 |
» Details |
|
|
|
|
| » TextWiz 2.1
|
| Powerful, multi purpose utility which performs several handy functions on text,html or any type files or blocks of text from the clipboard. Includes a powerful search and replace feature which, unlike many word processors, allows you to search for and rep ... |
|
| Harmony Hollow Software | 1327KB | Windows 95/98/NT/2000 | | Downloads: 1729 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Advanced Bughound 1.1
|
| Advanced Bughound is a new bug/feature/client tracking tool. We designed Advanced Bughound to be user friendly and very easy to use. People using Advanced Bughound will feel right at home after minutes of use. While it is easy to use, it was designed to b ... |
|
| Sault Custom Programming | 3787KB | Windows 95/98/NT/2000 | $79.00 | Downloads: 1695 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » MU-Trace 1.01
|
| Mu-Trace can help programmers who are working on a bigger project and are working in a group. In comparison with a standard output debugging window MU-Trace has many additional features. You can add up to 255 users and define an individual color per user. ... |
|
| Image Integration | 514k | Windows NT only | $0 | Downloads: 1580 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » II_AddIn1 1.0
|
| II_AddIn1 is the No. One Add-In for Microsoft Developer Studio, Visual C++ and Java edition. It displays function definitions or selected lines containing keywords in a separate window and jumps to the selected line. You can define individual colors per k ... |
|
| Image Integration | 433k | Windows 98/NT | $25 | Downloads: 1683 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » RTF Report Generator 1.02
|
| RTF Report Generator is a native Delphi VCL component that implements a flexible and powerful report generation engine. The result of the RTFReport is a ready-to-print editable Rich Text Format (RTF) document. In order to produce reports this engine util ... |
|
| Alexander Eltsyn | 381 Kb | Windows 95/98/NT/2000 | | Downloads: 1646 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Extended Calendar 1.0
|
| Extended Calendar is a Delphi component that allows you to implement a customizable flat calendar. ... |
|
| Tomas Koutny | 13 Kb | Windows 95/98/NT/2000 | | Downloads: 1642 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » TDotMatrix5x7 1.01
|
| TDotMatrix5x7 is a Delphi component used to draw a five by seven size dot matrix on your Delphi`s form. TDotMatrix5x7 lets you display all seven-bit ASCII characters, including alphanumeric characters (A..Z, a..z, 1..9), some Greek characters (alpha, bet ... |
|
| ADC-Soft | 125 Kb | Windows 95/98/NT/2000 | | Downloads: 1648 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » TSevenSegment 2.01
|
| TSevenSegment is a Delphi component used to draw seven segment displays on your form. TSevenSegment can display: numeric values, such as `123`, `123.45`, and `1E100`; time values, such as `10:00:00`, and `12:30:45 PM`; and alphanumeric values, such as `E ... |
|
| ADC-Soft | 155 Kb | Windows 95/98/NT/2000 | | Downloads: 1554 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » XDB Engine 1.0
|
| XDB Engine is a database engine that can be also used as an universal data container. XDB Engine implements an object oriented database kernel that allows you to implement your own database look to any data in your applications. The interface hides any d ... |
|
| Tomas Koutny | 242 Kb | Windows 95/98/NT/2000 | | Downloads: 1716 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » SimpleRegistry Control 2.11
|
| SimpleRegistry Control provides a simple way to access the Windows Registry from Visual Basic. This control allows you to access the Windows Registry in much more intuitive and simple way then the Win32 Registry APIs. It exposes the building blocks of th ... |
|
| Realtime Performance, Inc. | 208 Kb | Windows 95/98/NT/2000 | | Downloads: 1673 |
| Date added: Sep 22, 2005 |
» Details |
|
|
|
|
| |
